<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->


<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en-us" xml:lang="en-us">
<head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
   
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="DC.Type" content="topic">
<meta name="DC.Title" content="Viewing Environment Information of the SQL Server Database">
<meta name="product" content="">
<meta name="DC.Relation" scheme="URI" content="en-us_topic_0000001839165613.html">
<meta name="prodname" content="">
<meta name="version" content="">
<meta name="brand" content="30-OceanProtect Appliance 1.5.0-1.6.0 Help Center">
<meta name="DC.Publisher" content="20240608">
<meta name="DC.Format" content="XHTML">
<meta name="DC.Identifier" content="EN-US_TOPIC_0000001839245633">
<meta name="DC.Language" content="en-us">
<link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
<title>Viewing Environment Information of the SQL Server Database</title>
</head>
<body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px"><a name="EN-US_TOPIC_0000001839245633"></a><a name="EN-US_TOPIC_0000001839245633"></a>

<h1 class="topictitle1">Viewing Environment Information of the SQL Server Database</h1>
<div><p>After a SQL Server database is registered with <span>OceanProtect</span>, you can view details about the database, the host where it resides, and the cluster or availability group to which it belongs on the management page.</p>
<div class="section"><h4 class="sectiontitle">Procedure</h4><ol><li><span>Choose <span class="uicontrol" id="EN-US_TOPIC_0000001839245633__en-us_topic_0000001839142377_uicontrol114088356363"><b><span id="EN-US_TOPIC_0000001839245633__en-us_topic_0000001839142377_text1840913533616"><strong>Protection</strong></span> &gt; Databases &gt; SQL Server</b></span>.</span></li><li><span>View the database information on the <span class="uicontrol"><b><span><strong>Databases</strong></span></b></span> tab.</span><p><div class="p">The information about the scanned database is displayed.<ol type="a"><li><a href="#EN-US_TOPIC_0000001839245633__table2382789197">Table 1</a> describes the database information.
<div class="tablenoborder"><a name="EN-US_TOPIC_0000001839245633__table2382789197"></a><a name="table2382789197"></a><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001839245633__table2382789197" frame="border" border="1" rules="all"><caption><b>Table 1 </b>Database information</caption><colgroup><col style="width:20.380000000000003%"><col style="width:79.62%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="20.380000000000003%" id="mcps1.3.2.2.2.2.1.1.1.2.2.3.1.1"><p>Parameter</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="79.62%" id="mcps1.3.2.2.2.2.1.1.1.2.2.3.1.2"><p>Description</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="20.380000000000003%" headers="mcps1.3.2.2.2.2.1.1.1.2.2.3.1.1 "><p><span><strong>Name</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="79.62%" headers="mcps1.3.2.2.2.2.1.1.1.2.2.3.1.2 "><p>Database name.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.380000000000003%" headers="mcps1.3.2.2.2.2.1.1.1.2.2.3.1.1 "><p><span><strong>Owning Host/Cluster</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="79.62%" headers="mcps1.3.2.2.2.2.1.1.1.2.2.3.1.2 "><p>Name of the host or cluster where the database resides.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.380000000000003%" headers="mcps1.3.2.2.2.2.1.1.1.2.2.3.1.1 "><p><span><strong>Owning Instance</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="79.62%" headers="mcps1.3.2.2.2.2.1.1.1.2.2.3.1.2 "><p>Name of a single instance or cluster instance.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.380000000000003%" headers="mcps1.3.2.2.2.2.1.1.1.2.2.3.1.1 "><p><span><strong>SLAs</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="79.62%" headers="mcps1.3.2.2.2.2.1.1.1.2.2.3.1.2 "><p>If an SLA is associated with the database, the SLA name is displayed. Otherwise, <span class="uicontrol"><b>--</b></span> is displayed. </p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.380000000000003%" headers="mcps1.3.2.2.2.2.1.1.1.2.2.3.1.1 "><p><span><strong>SLA Compliance</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="79.62%" headers="mcps1.3.2.2.2.2.1.1.1.2.2.3.1.2 "><div class="p">Whether a backup job is successfully executed based on the backup frequency or backup window set in the SLA.<ul id="EN-US_TOPIC_0000001839245633__en-us_topic_0000001792344110_en-us_topic_0000001792344094_ul1823814519293"><li id="EN-US_TOPIC_0000001839245633__en-us_topic_0000001792344110_en-us_topic_0000001792344094_li9238184572919">If the backup time of a backup job (except for the first full backup) meets the backup time window or backup interval requirements and the backup job is executed successfully, SLA compliance is met.</li><li id="EN-US_TOPIC_0000001839245633__en-us_topic_0000001792344110_en-us_topic_0000001792344094_li189142052112912">If the backup time does not meet the backup time window or backup frequency requirements, for example, if the backup frequency set in the SLA for a backup job is once every half an hour but the backup time exceeds half an hour, SLA compliance is missed. In this case, you are advised to adjust the backup frequency or backup window.</li></ul>
</div>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.380000000000003%" headers="mcps1.3.2.2.2.2.1.1.1.2.2.3.1.1 "><p><span><strong>Protection Status</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="79.62%" headers="mcps1.3.2.2.2.2.1.1.1.2.2.3.1.2 "><p>Indicates whether the database is protected. </p>
<ul><li><span><strong>Unprotected</strong></span>: The database is not associated with an SLA, or the database is associated with an SLA but protection is disabled.</li><li><span><strong>Protected</strong></span>: The database is associated with an SLA and protection is enabled.</li><li><span><strong>Creating</strong></span>: The database is associated with an SLA and protection is being created.</li></ul>
</td>
</tr>
</tbody>
</table>
</div>
</li><li>Click the name and check the overview, copy information, and jobs. <ul><li>Overview<p>The SLA information, job execution time, and total number of copies are displayed.</p>
</li><li>Copy data<p>You can search for copies by year, month, or day.</p>
<p>If <span><img src="en-us_image_0000001839245929.png"></span> is displayed below the time, a copy at that time exists.</p>
</li><li>Job<p>Backup and recovery jobs are displayed.</p>
</li></ul>
</li></ol>
</div>
</p></li><li><span>On the <span class="uicontrol"><b>Cluster</b></span> tab page, view the SQL Server cluster information.</span><p><p>If a database on a cluster has been registered, the cluster information is displayed on the page.</p>
<div class="p"><a href="#EN-US_TOPIC_0000001839245633__table664941173815">Table 2</a> describes the displayed cluster information.
<div class="tablenoborder"><a name="EN-US_TOPIC_0000001839245633__table664941173815"></a><a name="table664941173815"></a><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001839245633__table664941173815" frame="border" border="1" rules="all"><caption><b>Table 2 </b>Cluster information</caption><colgroup><col style="width:20.31%"><col style="width:79.69000000000001%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="20.31%" id="mcps1.3.2.2.3.2.2.2.2.3.1.1"><p>Parameter</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="79.69000000000001%" id="mcps1.3.2.2.3.2.2.2.2.3.1.2"><p>Description</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="20.31%" headers="mcps1.3.2.2.3.2.2.2.2.3.1.1 "><p><span><strong>Name</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="79.69000000000001%" headers="mcps1.3.2.2.3.2.2.2.2.3.1.2 "><p>Name of a database cluster.</p>
<ul><li>If you click the cluster name, host members and all authenticated databases in the cluster are displayed.</li></ul>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.31%" headers="mcps1.3.2.2.3.2.2.2.2.3.1.1 "><p><span><strong>Status</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="79.69000000000001%" headers="mcps1.3.2.2.3.2.2.2.2.3.1.2 "><div class="p">Cluster status.<ul><li><span>Online</span>: When a host is powered on and ProtectAgent on the host is running properly, the <span class="uicontrol"><b><span>Status</span></b></span> of the host is <span class="uicontrol"><b><span>Online</span></b></span>.<p>If there are online hosts in a cluster, the cluster status is <span class="uicontrol"><b><span>Online</span></b></span>.</p>
</li><li><span>Offline</span>: When a host is shut down or ProtectAgent on the host is faulty, the <span class="uicontrol"><b><span>Status</span></b></span> of the host is <span class="uicontrol"><b><span>Offline</span></b></span>.<p>If all hosts in a cluster are offline, the <strong>status </strong>of the cluster is <span class="uicontrol"><b><span>Offline</span></b></span>.</p>
</li></ul>
</div>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.31%" headers="mcps1.3.2.2.3.2.2.2.2.3.1.1 "><p><span><strong>Owner</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="79.69000000000001%" headers="mcps1.3.2.2.3.2.2.2.2.3.1.2 "><p>Data protection administrator of a cluster. </p>
<p>If a data protection administrator is authorized for the cluster, the name of the data protection administrator is displayed. If no data protection administrator is authorized, <strong>--</strong> is displayed.</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</p></li></ol>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="en-us_topic_0000001839165613.html">SQL Server Database Environment</a></div>
</div>
</div>

<div class="hrcopyright"><hr size="2"></div><div class="hwcopyright">Copyright &copy; Huawei Technologies Co., Ltd.</div></body>
</html>